home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / mrcconvert.sql < prev    next >
Text File  |  2000-05-12  |  840b  |  29 lines
  1. /* RCSVER $Id: mrcconvert.sql,v 1.1 1999-04-05 11:57:47-05 evan CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        mrcconvert
  6. * Date:        3/22/1999    
  7. * memo:        Evan M. Ghormley    
  8. * Description:    Create the mrcconvert table. 
  9. * Changes:
  10. ************************************************************************* */
  11. CREATE TABLE mrcconvert
  12. (
  13.     insert_date        DATE,
  14.     mrc_batch_number    NUMBER(38),
  15.     count_date        DATE,
  16.     filename        VARCHAR2(30),
  17.      subbatch_seq        NUMBER(38),
  18.      batch_seq        NUMBER(38),    
  19.      convert_status        NUMBER(38)
  20. );
  21.  
  22.  
  23. /* *********************************
  24.  * Relationships:
  25.  *
  26.  * subbatch_seq     1:1    Subbatch.subbatch_seq
  27.  * batch_seq         1:1    Batch.subbatch_seq
  28.  ********************************** */
  29.